postgresql administration tutorial

command line mode: \q(7) Login database: psql-u dbuser-d exampledb-h 127.0.0.1-p 5432 into the exampledb=>The parameters of the above command have the following meanings:-u Specify the user,-D specify the database,-h specifies the server,-p specifies the port.(8) Basic Operation instruction# Creating a new Table CREATE table USER_TBL (name VARCHAR, signup_date date);# Inserting data insert into USER_TBL (name, signup_date) VALUES (' Zhang San ', ' 2013-12-22 ');# Select the Record select * from

=" 0 "alt=" wps3D04.tmp "src=" Http://s3.51cto.com/wyfs02/M01/9D/80/wKioL1mBORmy-D4fAAD7Ccj8EnA633.jpg "width=" 574 "height=" 454 "/>18, the front we talked about is the operation of the graphical interface, in fact, for Windows I prefer the GUI operation, but in order to improve operational efficiency, PowerShell CLI is a good thing, let's use the command line migration to try:MOVE-VM testserver01.testad.local-computername win2012r2-test03-destinationhost TestServer02.testad.localThis article f

PostgreSQL installation and configuration tutorial on Windows and postgresql installation tutorial PostgreSQL extension PostGIS is the most famous open source GIS database.Installing PostgreSQL is the first step. 1. Download the b

PostgreSQL tutorial (18): client commands (2), postgresql tutorial VII. pg_dump: Pg_dump is a tool used to back up PostgreSQL databases. It can even perform a full and consistent backup when the database is being used concurrently without blocking access to the database by o

PostgreSQL tutorial (14): database maintenance, postgresql tutorial I. Disk Space Restoration: In PostgreSQL, the data rows deleted or updated using the delete and update statements are not actually deleted, the physical address of the old data row sets the row status to del

Commonly used time and date scripts in PostgreSQL tutorial, postgresql tutorial Obtain System Time Functions select now(); --2013-11-28 16:20:25.259715+08select current_timestamp; --2013-11-28 16:20:38.815466+08select current_date; --2013-11-28select current_time; --16:21:08.981171+08 Time Calculation--

PostgreSQL database server listener settings and Client Connection Methods tutorial, postgresql Server As we all know, PostgreSQL is a free object-relational database server (Database Management System). It is an open-source database system that can be used for free. This article describes in detail the listener settin

PostgreSQL tutorial (5): Functions and operators (1), postgresql Operators I. logical operators: Common logical operators include AND, OR, and not. Its semantics is exactly the same as that of logical operators in other programming languages. Ii. Comparison operators: The following is a list of comparison operators provided by

PostgreSQL tutorial (13): database management details, postgresql details I. Overview: A database can be considered as a name set of an SQL object (database object). Generally, each database object (table, function, etc.) belongs to only one database. However, for some system tables, such as pg_database, it belongs to the entire cluster. More accurately, a databa

Tutorial on installing and using the extension module on PostgreSQL, postgresql extension module Installation Module Note: My runtime environments are Ubuntu 10.04 and PostgreSQL 8.4. First, install the postgresql-contrib package and restart the database server. Then, check

Manual PostgreSQL database initialization tutorial in windows, initialize postgresql Environment: win7 64 sp1PG: 9.3.5 1. Create the postgres user, and the password is also postgres: net user postgres postgres /add 2. Create a data directory under the root directory of the database: C:\Program Files\PostgreSQL\9.3>md d

PostgreSQL tutorial (1): Detailed description of data tables and detailed description of postgresql I. Table definition: For any relational database, tables are the core and basic object units of data storage. Now let's start from here.1. Create a table:Copy codeThe Code is as follows:Create table products (Product_no integer,Name text,Price numeric);2. delete a

PostgreSQL tutorial (10): Performance Improvement tips and postgresql Performance Improvement 1. Use EXPLAIN: PostgreSQL generates a query plan for each query, because selecting the correct query path has a critical impact on performance. PostgreSQL itself contains a schedul

PostgreSQL tutorial (8): Index details, postgresql Index I. Index type: PostgreSQL provides multiple index types: B-Tree, Hash, GiST, and GIN. Because they use different algorithms, each index type has a suitable Query type, the create index Command creates a B-Tree INDEX.1. B-Tree:Copy codeThe Code is as follows:Creat

Tutorial on implementing recursive query in PostgreSQL, postgresql Recursion Introduction I am working on a program in nilint32 (Open Source !) It is used to design and initiate surveys. The following is an example of a survey: Internally, it indicates the drop: A Survey involves many questions (question ). A series of problems can be classified into (optional)

PostgreSQL tutorial (6): Functions and operators (2), postgresql Operators 6. Pattern Matching: PostgreSQL provides three methods for implementing pattern matching: SQL LIKE operator, closer SIMILAR TO operator, and POSIX-style regular expression.1. LIKE:Copy codeThe Code is as follows:String LIKE pattern [ESCAPE escap

PostgreSQL tutorial (16): System View Details, postgresql View I. pg_tables: This view provides access to useful information about each table in the database. Name Type Reference Description Schemaname Name Pg_namespace.nspname The schema name of the table. Tablename Name Pg_class.relname Ta

need to start psql to experiment with the examples in this tutorial. You can activate it for the mydb database with the following command: Psql MyDBIf you do not provide a database name, then its default value is your user account name. You should have known this way in the previous section of using createdb .In psql , you will see the following welcome message: Psql (9.6.0) Type ' help ' for help. Mydb=>The last line may also be: mydb=# This prom

Opencms9.5 for postgresql installation tutorial, opencms9 tutorial 1. Download and install postgresql. Http://www.enterprisedb.com/products-services-training/pgdownload#windows After downloading the latest version for the first time, an error is reported when you click the installer. Select Version9.0.19 for down

=org.apache.catalina.connector.URI_ENCODING:add(value="UTF-8") /system-property=org.apache.catalina.connector.USE_BODY_ENCODING_FOR_QUERY_STRING:add(value=true) /subsystem=webservices:write-attribute(name=wsdl-host, value=jbossws.undefined.host) /subsystem=webservices:write-attribute(name=modify-wsdl-address, value=true) :reload If you have an Apache service in front of Wildfly, execute the following command, or do not: /subsystem=undertow/server=default-server/ajp-listener=ajp-lis